{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Soft Signage"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":30,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Soft Signage","index":0,"n_rows":50,"n_cols":42,"rows_kept":50,"cut":false,"hidden":false,"merged":[[47,14,47,15],[47,2,47,6],[47,7,47,8],[47,9,47,10],[47,12,47,13],[36,2,36,3],[36,5,36,6],[39,5,39,6],[35,5,35,6],[17,5,17,6],[17,7,17,28],[17,2,17,3],[21,1,21,28],[26,5,26,6],[26,2,26,3],[26,7,26,25],[25,7,25,28],[24,1,24,28],[23,1,23,3],[23,5,23,11],[23,12,23,15],[23,17,23,24],[18,2,18,3],[20,1,20,28],[22,1,22,28],[25,2,25,3],[25,5,25,6],[27,2,27,3],[27,5,27,6],[27,7,27,25],[28,1,28,28],[34,1,34,28],[36,7,36,25],[33,1,33,28],[44,2,44,3],[35,7,35,28],[41,1,41,28],[43,4,43,25],[44,4,44,25],[1,1,1,28],[3,1,4,28],[9,1,9,25],[7,1,7,25],[5,1,5,25],[6,18,6,24],[5,26,11,26],[5,27,11,27],[5,28,11,28],[10,1,10,25],[8,19,8,25],[8,11,8,12],[8,7,8,10],[8,13,8,16],[2,1,2,28],[3,41,3,43],[42,1,42,28],[6,1,6,4],[6,5,6,13],[8,17,8,18],[8,5,8,6],[6,14,6,17],[11,1,11,25],[12,1,12,28],[13,1,13,28],[39,2,39,3],[14,1,15,28],[16,1,16,28],[18,28,19,28],[40,1,40,28],[8,1,8,4],[29,1,29,28],[39,7,39,25],[37,2,37,3],[38,2,38,3],[37,5,37,6],[38,5,38,6],[37,7,37,25],[38,7,38,25],[49,2,49,6],[49,7,49,8],[49,9,49,10],[49,12,49,13],[49,14,49,15],[35,2,35,3],[33,33,33,34],[3,30,3,33],[3,35,3,39],[19,7,19,25],[18,26,19,26],[18,27,19,27],[30,1,30,28],[32,1,32,28],[31,2,31,3],[31,5,31,6],[31,7,31,25],[18,5,18,6],[18,7,18,25],[19,2,19,3],[19,5,19,6],[43,2,43,3],[45,2,45,3],[45,4,45,25]]}
[]
[]
[null,"BILL OF MATERIALS"]
[null,{"$f":"AE4&AI4&AJ4&AO4&AP4","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(Frame=1,\"\",IF(FrmTyp=1,\"1'' Front Load Soft Signage Frame\",IF(FrmTyp=2,\"3-1/2'' Front Load Soft Signage Frame\",\"\"))))","v":""},null,null,null,{"$f":"IF(KQ=0,\"\",IF(Frame=1,\"\",IF(FrmTyp=1,\" with\",IF(FrmTyp=2,\" with\",\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Frame=1,\"\",IF(FrmTyp=1,\" 2 Piece Grip Strip\",IF(FrmTyp=2,\" Front Load Grip Strip\",\"\"))))","v":""},null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(ZMC=2,\"\",IF(ZMC=1,\" and\",\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(ZMC=2,\"\",IF(ZMC=1,\" Z-Clip Mounting Bracket\",\"\")))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lengths Required","Lengths Used","Drops Used"]
[null,"Customer  ",null,null,null,null,null,null,null,null,null,null,null,null,"Order#   "]
[]
[null,"Kit Quantity  ",null,null,null,0,null,"Height  ",null,null,null,0,null,"Width",null,null,null,0]
[]
[null,"Enter Fractions as Decimals"]
[]
[null,"Extrusion"]
[]
[null,"Frame",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Frame",2,"Anodized"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Frame Type",{"$f":"IF(Anod=1,\"\",IF(Anod=2,\"A\",\"\"))","v":"A"},"Anodized"]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"  Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(Frame=1,\"\",IF(FrmTyp=1,KQ*2,IF(FrmTyp=2,KQ*2,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Frame=1,\"\",IF(FrmTyp=1,Hgt,IF(FrmTyp=2,Hgt,\"\"))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Frame=1,\"\",IF(FrmTyp=1,\"3092\"&ANO,IF(FrmTyp=2,\"3095\"&ANO,\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Frame=1,\"\",IF(FrmTyp=1,\" 1'' Front Load Soft Signage Frame - Mitered both ends\",IF(FrmTyp=2,\" 3-1/2'' Front Load Soft Signage Frame - Mitered both ends\",\"\"))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Frame=1,\"\",IF(FrmTyp=1,KQ*2,IF(FrmTyp=2,KQ*2,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Frame=1,\"\",IF(FrmTyp=1,Wdt,IF(FrmTyp=2,Wdt,\"\"))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Frame=1,\"\",IF(FrmTyp=1,\"3092\"&ANO,IF(FrmTyp=2,\"3095\"&ANO,\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Frame=1,\"\",IF(FrmTyp=1,\" 1'' Front Load Soft Signage Frame - Mitered both ends\",IF(FrmTyp=2,\" 3-1/2'' Front Load Soft Signage Frame - Mitered both ends\",\"\"))))","v":""}]
[]
[null,"  Soft Signage Support (Optional)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Support"]
[]
[null,null,null,null,0]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"  Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"Vertical",{"$f":"IF(AND(Vert=TRUE,VertSup=0),KQ*HorzSup,IF(Vert=TRUE,VertSup*KQ))","v":false}]
[null,{"$f":"IF(KQ=0,\"\",IF(Support=1,\"\",IF(FrmTyp=1,\"\",IF(Vert=FALSE,\"\",IF(FrmTyp=2,KQ*VertSup,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Support=1,\"\",IF(FrmTyp=1,\"\",IF(Vert=FALSE,\"\",IF(FrmTyp=2,Hgt-0.862,\"\")))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Support=1,\"\",IF(FrmTyp=1,\"\",IF(Vert=FALSE,\"\",IF(FrmTyp=2,\"3085\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Support=1,\"\",IF(FrmTyp=1,\"\",IF(Vert=FALSE,\"\",IF(FrmTyp=2,\" Soft Signage Support\",\"\")))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"Horizontal",{"$f":"IF(AND(Vert=FALSE,Horz=TRUE),HorzSup,IF(AND(Vert=TRUE,VertSup=0),KQ*HorzSup,IF(AND(Vert=TRUE,VertSup=1),2*KQ*HorzSup,IF(AND(Vert=TRUE,VertSup=2),3*KQ*HorzSup,IF(AND(Vert=TRUE,VertSup=3),4*KQ*HorzSup,IF(AND(Vert=TRUE,VertSup=4),5*KQ*HorzSup,IF(AND(Vert=TRUE,VertSup=5),6*KQ*HorzSup,IF(AND(Vert=TRUE,VertSup=6),7*KQ*HorzSup,))))))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Support=1,\"0\",IF(AND(Vert=TRUE,Horz=FALSE),VertTot*4,IF(AND(Vert=FALSE,Horz=TRUE),HorzTot*4,IF(AND(Vert=TRUE,Horz=TRUE),(VertTot+HorzTot)*4,\"0\"))))","v":"0"},null,null,null,{"$f":"IF(KQ=0,\"\",IF(Support=1,\"\",IF(FrmTyp=1,\"\",IF(Horz=FALSE,\"\",IF(Wdt<=71,\"\",IF(FrmTyp=2,Wdt-0.862,\"\"))))))","v":""},{"$f":"IF(AND(VertSup=0,HorzSup=1),HorzL,IF(VertSup=1,(HorzL-1.095)/2,IF(VertSup=2,(HorzL-2.19)/3,IF(VertSup=3,(HorzL-3.285)/4,IF(VertSup=4,(HorzL-4.38)/5,IF(VertSup=5,(HorzL-5.475)/6,IF(VertSup=6,(HorzL-6.57)/7)))))))","v":false}]
[]
[null,"Z-Clip Mounting Bracket (Optional)"]
[]
[null,{"$f":"IF(KQ=0,\"\",IF(ZMC=2,\"\",1*KQ))","v":""},{"$f":"IF(KQ=0,\"\",IF(ZMC=2,\"\",IF(FrmTyp=1,Wdt-4,IF(FrmTyp=2,Wdt-1.375,\"\"))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(ZMC=2,\"\",\"3099\"))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(ZMC=2,\"\",\" Z-Clip Mounting Bracket\"))","v":""}]
[]
[null,"Grip Strip",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Grip Strip",1,"Grip Strip Type"]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"  Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(Grip=1,\"\",IF(GrpStp=1,KQ*2,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(Grip=1,\"\",IF(GrpStp=1,Hgt-0.39,\"\")))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Grip=1,\"\",IF(GrpStp=1,\"3098\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Grip=1,\"\",IF(GrpStp=1,\" Front Load Grip Strip - Both ends straight cut\",\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[null,{"$f":"IF(KQ=0,\"\",IF(Grip=1,\"\",IF(GrpStp=1,KQ*2,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(Grip=1,\"\",IF(GrpStp=1,Hgt-1.172,\"\")))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Grip=1,\"\",IF(GrpStp=1,\"3098\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Grip=1,\"\",IF(GrpStp=1,\" Front Load Grip Strip - Both ends straight cut\",\"\")))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Grip=1,\"\",IF(GrpStp=1,KQ*2,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(Grip=1,\"\",IF(GrpStp=1,Wdt-0.39,\"\")))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Grip=1,\"\",IF(GrpStp=1,\"3098\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Grip=1,\"\",IF(GrpStp=1,\" Front Load Grip Strip - Both ends straight cut\",\"\")))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Grip=1,\"\",IF(GrpStp=1,KQ*2,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(Grip=1,\"\",IF(GrpStp=1,Wdt-1.172,\"\")))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Grip=1,\"\",IF(GrpStp=1,\"3098\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Grip=1,\"\",IF(GrpStp=1,\" Front Load Grip Strip - Both ends straight cut\",\"\")))","v":""}]
[]
[null,"Hardware"]
[]
[null,{"$f":"IF(KQ=0,\"\",IF(Frame=1,\"\",IF(FrmTyp=1,4*KQ,IF(FrmTyp=2,(BodyA+SuppA),\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Frame=1,\"\",IF(FrmTyp=1,\"5890\",IF(FrmTyp=2,\"5895\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Frame=1,\"\",IF(FrmTyp=1,\" 2 Piece Corner Key - One per corner \",IF(FrmTyp=2,\" 3-1/2'' Front Load Soft Signage Frame Corner Angle / Support Angle Assembly \",\"\"))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"KQ*8","v":0},"Body Angles"]
[null,{"$f":"IF(KQ=0,\"\",IF(Frame=1,\"\",IF(FrmTyp=1,1*KQ,IF(FrmTyp=2,1*KQ,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Frame=1,\"\",IF(FrmTyp=1,\"5897\",IF(FrmTyp=2,\"5897\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Frame=1,\"\",IF(FrmTyp=1,\"Fabric Removal Pull Tab and Attachment Screw - One corner\",IF(FrmTyp=2,\" Fabric Removal Pull Tab and Attachment Screw - One corner\",\"\"))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Frame=1,\"\",IF(FrmTyp=1,2*KQ,IF(AND(AND(FrmTyp=2,KQ>=1,KQ<=10)),\"5\",IF(AND(AND(FrmTyp=2,KQ>=11,KQ<=20)),\"10\",IF(AND(FrmTyp=2,KQ>=21),\"15\",\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Frame=1,\"\",IF(FrmTyp=1,\"5890-Screw\",IF(FrmTyp=2,\"5895-Screw\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Frame=1,\"\",IF(FrmTyp=1,\" Extra 2 Piece Corner Key Screws \",IF(FrmTyp=2,\" Extra Corner Angle Screws \",\"\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Z-Clip"]
[null,null,"Face Fabric Trim Size:",null,null,null,null,"Height",null,{"$f":"IF(KQ=0,\"0\",Hgt+2)","v":"0"},null,"x","Width",null,{"$f":"IF(KQ=0,\"0\",Wdt+2)","v":"0"}]
[]
[null,null,"Back Trim Size:",null,null,null,null,"Height",null,{"$f":"IF(KQ=0,\"0\",IF(FrmTyp=2,Hgt-0.1875,\"\"))","v":"0"},null,"x","Width",null,{"$f":"IF(KQ=0,\"0\",IF(FrmTyp=2,Wdt-0.1875,\"\"))","v":"0"}]